package com.baidu.yyb.constant;

/**
 * 常量
 * @author LiuTong
 */
public class StringName {
    public final static String DB_NAME = "noteDataBase";
    public final static int DB_VERSION = 1000;

    public final static int MIN_LIMIT = 6;
    public final static int MAX_USERNAME = 12;
    public final static int MAX_PASSWORD = 20;
    public final static int PHONE_NUMBER_LIMIT = 11;



    public final static String DB_CREATE_DATABASE = "noteDataBase";

    public static final String DB_NOTE_TABLE = "Notes";

    public static final String DB_DELETE_TABLE = "DeleteTable";

    public static final String DB_USER_TABLE= "userTable";

    public static final String DB_NOTE_ID = "id";
    public static final String DB_NOTE_USERID = "userId";
    public static final String DB_NOTE_PASSWORD = "userPassword";
    public static final String DB_NOTE_PHONE = "userPhone";

    public static final String DB_NOTE_CONTENTS = "noteContent";
    public static final String DB_NOTE_TYPE = "noteType";
    public static final String DB_NOTE_NOTE = "isNote";
    public static final String DB_NOTE_DELETE = "isDelete";
    public static final String DB_NOTE_COLLECT = "isCollect";
    public static final String DB_NOTE_DATE = "noteCreateTime";
    public static final String DB_DEL_ID = "deleteId";
    public static final String DB_DEL_NOTES_ID = "noteDeleted";
    public static final String DB_DEL_TIME = "delTime";

    public static final String CREATE_DATABASE = "CREATE DATABASE '"+DB_CREATE_DATABASE+"'";

    /****
     * 创建笔记表
     */
    public static final String CREATE_NOTES_CONTENT = "create table "
            + DB_NOTE_TABLE + "('"+DB_NOTE_ID+"' long," +
            "'"+DB_NOTE_USERID+"' char(12)," +
            "'"+DB_NOTE_TYPE+"' int," +
            "'"+DB_NOTE_CONTENTS+"' String," +
            "'"+DB_NOTE_COLLECT+"' int," +
            "'"+DB_NOTE_DATE+"' long," +
            "'"+DB_NOTE_NOTE+"' int," +
            "'"+DB_NOTE_DELETE+"' int);";//isDelete 0 未删除 1 虚拟删除 2 完全删除


    /****
     * 创建删除表
     */
    public static final String CREATE_DEL_TABLE = "create table " + DB_DELETE_TABLE
            + "( '"+DB_DEL_ID+"' long," +
            "'"+DB_NOTE_ID+"' int)";

    /****
     * 创建删除表
     */
    public static final String CREATE_USER_TABLE = "create table " + DB_USER_TABLE +
            "('"+DB_NOTE_USERID+"' char(12)," +
            "'"+DB_NOTE_PASSWORD+"' char(20)," +
            "'"+DB_NOTE_PHONE+"' char(11))";

    public static final String[] MENU_SPR_LIST_STR = {"工作日志", "私密记录", "个人生活", "旅游", "知识文库", "其他记录"};
    public static final String[] MENU_LIST_TOP = {"所有记录", "我的收藏"};

}
